This model dimension represents accounting projects in Financials and is based on the IFS Cloud dimension DIM_ACCOUNTING_PROJECT. All models that refers to this dimension will have the attributes and hierarchies as described below.
Natural parent is company, i.e. each company has its on set of accounting projects.
Attribute | Description (where applicable) |
Accounting Project | Represents the Accounting Project Code |
Accounting Project Code | Represents the Accounting Project Name |
Accounting Project Desc | Represents the description of the Accounting Project |
Accounting Project Group | Represents the PROJECT_GROUP_DESC, i.e. description of the project group |
Accounting Project Group Code | Accounting project group code |
Accounting Project Status | Represents the PROJECT_STATUS_DESC, i.e. description of the project status |
Accounting Project Type | Represents the PROJECT_TYPE_DESC, i.e. the project type description |
Accounting Project Type Code | Accounting project type code |
Company | Represents the Company Code of the company where the accounting project is defined |
ID | Built as ACCOUNTING PROJECT GROUP CODE + '^' + ACCOUNTING PROJECT CODE |
Project Origin Desc | Represents the origin of the project |
Model Name |
Cash Planning |
General Ledger |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
ACCOUNTING PROJECT | DIM_ACCOUNTING_PROJECT_BI | DIM_ACCOUNTING_PROJECT_BI | DIM_ACCOUNTING_PROJECT | On Line |